<html>
<head>
<link rel=stylesheet type=text/css href=day8.css>
<title>Node DYgraphs: Table</title>
</head>
<body>
<center><h2>Node Database</h2></center>
<table>
<tr>
<td><b>Navigation:</b></td>
<td><b><a href=day8.php>Table</a></b></td>
<td><b><a href=graph.php>Graph</a></b></td>
</tr>
</table>
<center>
<h2>Table of Gathered Data from Nodes</h2>
<table id=table border=1>
<tr id=tr>
<td id=td>Timestamp</td>
<td id=td>Node</td>
<td id=td>Xval</td>
<td id=td>Yval</td>
<td id=td>Zval</td>
<td id=td>Mval</td>
<td id=td>Purged</td>
</tr>
<?php
$con = mysql_connect("127.0.0.1","kkmq12345","updews");
mysql_select_db("dews_training");
$query = mysql_query("SELECT * FROM accel");
if ($query == FALSE)
{
die(mysql_error());
}
while($row = mysql_fetch_array($query))
{
echo "<tr id=tr><td id=td>" . $row['timestamp'] . "</td><td id=td>" . $row['node'] . "</td><td id=td>" . $row['xval'] . "</td><td id=td>" . $row['yval'] . "</td><td id=td>" . $row['zval'] . "</td><td id=td>" . $row['mval'] . "</td><td id=td>" . $row['purged'] . "</td></tr>";
}
mysql_close($con)
?>

</script>
</table>
</center>
</body>
</html>